var express=require("express");
var pool=require("../pool.js");
let router=express.Router();
router.get('/ningmeng_sale',(req,res)=>{
  var sql=`select * from xhy_store where type_store="柠檬时代" order by sale_store desc;`;
  pool.query(sql,(err,result)=>{
    if(err) throw err;
    res.json(result);
  })
});
router.get('/ningmeng_range',(req,res)=>{
  var sql=`select * from xhy_store where type_store="柠檬时代" order by range_store asc;`;
  pool.query(sql,(err,result)=>{
    if(err) throw err;
    res.json(result);
  })
});
router.get('/ningmeng_time',(req,res)=>{
  var sql=`select * from xhy_store where type_store="柠檬时代" order by time_store asc;`;
  pool.query(sql,(err,result)=>{
    if(err) throw err;
    res.json(result);
  })
});

module.exports=router;